USE [Tibet]
GO
/****** Object:  StoredProcedure [dbo].[SELPerfilMetricaPorNombre]    Script Date: 06/22/2011 18:02:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Patricia Valera
-- Create date: 22/05/2011
-- Description:	Procedimiento para traer los nombres de los perfiles de metricas
-- =============================================
ALTER PROCEDURE [dbo].[SELPerfilMetricaPorNombre] 
	@NombrePerfil Varchar(45)
		
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    SELECT * FROM [Tibet].[dbo].[Perfil_Metrica]
    WHERE [Tibet].[dbo].[Perfil_Metrica].[NombrePerfilMetrica] LIKE '%'+@NombrePerfil+'%';
								
END
